from tortoise import fields
from tortoise.models import Model

class Form_1_Data(Model):
    orderNumber = fields.CharField(max_length=512, pk=True)
    batchNumber = fields.CharField(max_length=512)
    materialName = fields.CharField(max_length=512)
    supplier = fields.CharField(max_length=512)
    arrivalTime = fields.CharField(max_length=512)
    arrivalQuantity = fields.CharField(max_length=512)
    qualityLevel = fields.CharField(max_length=512)
    qualityTime = fields.CharField(max_length=512)
    samplingRatio  = fields.CharField(max_length=512)
    samplingQuantity =  fields.CharField(max_length=512)
    defectiveQuantity  = fields.CharField(max_length=512)
    defectiveRate  = fields.CharField(max_length=512)
    appearanceDescription = fields.CharField(max_length=512)
    mildSeverity = fields.CharField(max_length=512)
    seriousSeverity  = fields.CharField(max_length=512)
    acceptance = fields.CharField(max_length=512)
    rejection  = fields.CharField(max_length=512)
    sizeDescription  = fields.CharField(max_length=512)
    mildSeverity1  = fields.CharField(max_length=512)
    seriousSeverity1  = fields.CharField(max_length=512)
    acceptance1  = fields.CharField(max_length=512)
    rejection1  = fields.CharField(max_length=512)
    functionDescription  = fields.CharField(max_length=512)
    mildSeverity2  = fields.CharField(max_length=512)
    seriousSeverity2 = fields.CharField(max_length=512)
    acceptance2  = fields.CharField(max_length=512)
    rejection2  = fields.CharField(max_length=512)
    remarks  = fields.CharField(max_length=5120)
    finalAcceptance  = fields.CharField(max_length=512)
    finalRejection  = fields.CharField(max_length=512)
    returnAll  = fields.CharField(max_length=512)
    selectiveUse  = fields.CharField(max_length=512)
    specialUse  = fields.CharField(max_length=512)
    inspector  = fields.CharField(max_length=512)

    class Meta:
        table = "Form_1_Data"
